<?php
include("../inc/global.inc");
?>
<HTML>
<HEAD>
<TITLE>管理后台</TITLE>
<META http-equiv=Content-Type content="text/html; charset=utf-8">
<LINK href="css/css.css" rel=stylesheet>
<script type='text/javascript' src="js/islogin.js"></script>
</HEAD>
<BODY>
<center>
  <table width="80%" border="0" cellspacing="0" cellpadding="0">
    <tr>
      <td height="45" align="center" bgcolor="#D8D8D8"><strong>管理后台数据统计</strong></td>
    </tr>
    <tr>
      <td bgcolor="#FFFFFF"><table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="#D8D8D8">
        <tr>
          <td width="25%" height="30" align="center" bgcolor="#FFFFFF">&nbsp;</td>
          <td width="25%" align="center" bgcolor="#FFFFFF">审核通过</td>
          <td width="25%" align="center" bgcolor="#FFFFFF">审核未通过</td>
          <td width="25%" align="center" bgcolor="#FFFFFF">新注册/发布</td>
        </tr>
        <tr>
          <td width="25%" height="30" align="center" bgcolor="#E8E8E8">普通会员</td>
          <td width="25%" align="center" bgcolor="#FFFFFF"><a href="member/index_2.php" style="text-decoration:underline;">查看</a></td>
          <td width="25%" align="center" bgcolor="#FFFFFF">
		  
		  <?php
		  $rs=@mysql_query("select count(id) from member where m_type='3' and m_sh='0' and m_cl='1' and m_mode=1");
		  $num=@mysql_result($rs,0);
		  ?>( <a href="member/index_3.php" style="text-decoration:underline;"><?=$num?></a> )</td>
		  <?php mysql_free_result($rs);?>
          <td align="center" bgcolor="#FFFFFF">
		  
		  <?php
		  $rs=@mysql_query("select count(id) from member where m_type='3' and m_cl='0' and m_mode=1");
		  $num=@mysql_result($rs,0);
		  ?>( <a href="member/index.php" style="text-decoration:underline;"><?=$num?></a> )&nbsp;&nbsp;<a href="m_sh.php" style="color:#FF0000;">批处理</a>
		  
		  </td>
		  <?php mysql_free_result($rs);?>
        </tr>
		<tr>
          <td width="25%" height="30" align="center" bgcolor="#E8E8E8">钻石会员</td>
          <td width="25%" align="center" bgcolor="#FFFFFF">
		  <?php 
		  $rs=@mysql_query("select count(id) from member where m_type='6' and m_sh='1' and m_mode=1");
		  $num=@mysql_result($rs,0);
		  ?>( <a href="member/com_vip_2.php" style="text-decoration:underline;color:#FF0000;"><?=$num?></a> )</td>
		  <?php mysql_free_result($rs);?>
          <td width="25%" align="center" bgcolor="#FFFFFF">
		  <?php
		  $rs=@mysql_query("select count(id) from member where m_type='6' and m_sh='0' and m_cl='1' and m_mode=1");
		  $num=@mysql_result($rs,0);
		  ?>( <a href="member/com_vip_3.php" style="text-decoration:underline;"><?=$num?></a> )</td>
		  <?php mysql_free_result($rs);?>
          <td align="center" bgcolor="#FFFFFF">
		  <?php
		  $rs=@mysql_query("select count(id) from member where m_type='6' and m_cl='0' and m_mode=1");
		  $num=@mysql_result($rs,0);
		  ?>( <a href="member/com_vip.php" style="text-decoration:underline;"><?=$num?></a> )</td>
		  <?php mysql_free_result($rs);?>
        </tr>
		<tr>
          <td width="25%" height="30" align="center" bgcolor="#E8E8E8">营业执照审核</td>
          <td width="25%" align="center" bgcolor="#FFFFFF">
		  <?php 
		  $rs=@mysql_query("select count(id) from member where m_rz_ok=1");
		  $num=@mysql_result($rs,0);
		  ?>( <?=$num?> )</td>
		  <?php mysql_free_result($rs);?>
          <td width="25%" align="center" bgcolor="#FFFFFF">
		  <?php
		  $rs=@mysql_query("select count(id) from member where m_rz_ok=0 and m_cl=1 and not m_rz_img = ''");
		  $num=@mysql_result($rs,0);
		  ?>( <?=$num?> )</td>
		  <?php mysql_free_result($rs);?>
          <td align="center" bgcolor="#FFFFFF">
		  <?php
		  $rs=@mysql_query("select count(id) from member where m_rz_ok=2");
		  $num=@mysql_result($rs,0);
		  ?>待审核营业执照：( <a href="member/rz_img.php" style="text-decoration:underline;"><?=$num?></a> )</td>
		  <?php mysql_free_result($rs);?>
        </tr>

        <tr>
          <td width="25%" height="30" align="center" bgcolor="#E8E8E8">产品</td>
          <td width="25%" align="center" bgcolor="#FFFFFF"><a href="product/index_2.php" style="text-decoration:underline;">查看</a></td>
		  
          <td width="25%" align="center" bgcolor="#FFFFFF">
		  <?php
		  $rs=@mysql_query("select count(id) from product where p_sh='0' and p_cl='1'");
		   $num=@mysql_result($rs,0);
		  ?>( <a href="product/index_3.php" style="text-decoration:underline;"><?=$num?></a> )</td>
		  <?php mysql_free_result($rs);?>
          <td align="center" bgcolor="#FFFFFF">
		  <?php
		  $rs=@mysql_query("select count(id) from product where p_cl='0' and m_type=3");
		   $num=@mysql_result($rs,0);
		  ?>( <a href="product/index.php" style="text-decoration:underline;"><?=$num?></a> )&nbsp;&nbsp;<a href="p_sh.php" style="color:#FF0000;">批处理</a>
		  &nbsp;&nbsp;<a href="p_sh_phone.php" style="color:#FF0000;">批处理电话</a>
		  </td>
		  <?php mysql_free_result($rs);?>
          </tr>
        <tr>
          <td width="25%" height="30" align="center" bgcolor="#E8E8E8">钻石会员产品</td>
          <td width="25%" align="center" bgcolor="#FFFFFF"><a href="product/index_2.php" style="text-decoration:underline;"></a></td>
		  
          <td width="25%" align="center" bgcolor="#FFFFFF">&nbsp;</td>
		  
          <td align="center" bgcolor="#FFFFFF">
		  <?php
		  $rs=@mysql_query("select count(id) from product where p_cl='0' and m_type=6");
		   $num=@mysql_result($rs,0);
		  ?>( <a href="product/vip_index.php" style="text-decoration:underline;"><?=$num?></a> )&nbsp;&nbsp;<a href="p_sh_vip.php" style="color:#FF0000;">批处理</a></td>
		  <?php mysql_free_result($rs);?>
          </tr>
        <tr>
          <td width="25%" height="30" align="center" bgcolor="#E8E8E8">buy</td>
          <td width="25%" align="center" bgcolor="#FFFFFF"><a href="buy/index_2.php" style="text-decoration:underline;">查看</a></td>
          <td width="25%" align="center" bgcolor="#FFFFFF">
		  <?php
		  $rs=@mysql_query("select count(id) from buy where b_sh='0' and b_cl='1'");
		   $num=@mysql_result($rs,0);
		  ?>( <a href="buy/index_3.php" style="text-decoration:underline;"><?=$num?></a> )</td>
		  <?php mysql_free_result($rs);?>
          <td align="center" bgcolor="#FFFFFF">
		  <?php
		  $rs=@mysql_query("select count(id) from buy where b_cl='0'");
		   $num=@mysql_result($rs,0);
		  ?>( <a href="buy/index.php" style="text-decoration:underline;"><?=$num?></a> )&nbsp;&nbsp;<a href="b_sh.php" style="color:#FF0000;">批处理</a></td>
		  <?php mysql_free_result($rs);?>
        </tr>
		
		
		
		
		
		
		
        <tr>
          <td width="25%" height="30" align="center" bgcolor="#F9F9F9">贷款管理</td>
          <td width="25%" align="center" bgcolor="#F9F9F9"><a href="jiedai/index_2.php" style="text-decoration:underline;">查看</a></td>
          <td width="25%" align="center" bgcolor="#F9F9F9">&nbsp;</td>
          <td align="center" bgcolor="#F9F9F9">
		  <?php
		  $rs=@mysql_query("select count(id) from jd_fangdai where fd_cl='0'");
		  $num=@mysql_result($rs,0);
		  ?>( <a href="jiedai/index.php" style="text-decoration:underline;"><?=$num?></a> )</td>
		  <?php mysql_free_result($rs);?>
        </tr>
		<tr>
          <td width="25%" height="30" align="center" bgcolor="#F9F9F9">借款管理</td>
          <td width="25%" align="center" bgcolor="#F9F9F9"><a href="jiedai/jiekuan_2.php" style="text-decoration:underline;">查看</a></td>
          <td width="25%" align="center" bgcolor="#F9F9F9"></td>
          <td align="center" bgcolor="#F9F9F9">
		  <?php
		  $rs=@mysql_query("select count(id) from jd_jiedai where jd_cl='0'");
		  $num=@mysql_result($rs,0);
		  ?>( <a href="jiedai/jiekuan.php" style="text-decoration:underline;"><?=$num?></a> )</td>
		  <?php mysql_free_result($rs);?>
        </tr>		
		
		
		<tr>
          <td width="25%" height="30" align="center" bgcolor="#F9F9F9">代理加盟</td>
          <td width="25%" align="center" bgcolor="#F9F9F9"><a href="jm/index_2.php" style="text-decoration:underline;">查看</a></td>
          <td width="25%" align="center" bgcolor="#F9F9F9"></td>
          <td align="center" bgcolor="#F9F9F9">
		  <?php
		  $rs=@mysql_query("select count(id) from jm_list where j_cl='0'");
		  $num=@mysql_result($rs,0);
		  ?>( <a href="jm/index.php" style="text-decoration:underline;"><?=$num?></a> )</td>
		  <?php mysql_free_result($rs);?>
        </tr>		
		<tr>
          <td width="25%" height="30" align="center" bgcolor="#F9F9F9">批发市场</td>
          <td width="25%" align="center" bgcolor="#F9F9F9"><a href="pifa/index_2.php" style="text-decoration:underline;">查看</a></td>
          <td width="25%" align="center" bgcolor="#F9F9F9"></td>
          <td align="center" bgcolor="#F9F9F9">
		  <?php
		  $rs=@mysql_query("select count(pf_list.id) from pf_list inner join  member on (pf_list.member_id=member.id)  where pf_list.p_cl='0'");
		  $num=@mysql_result($rs,0);
		  ?>( <a href="pifa/index.php" style="text-decoration:underline;"><?=$num?></a> )</td>
		  <?php mysql_free_result($rs);?>
        </tr>			
		
		
		
		
		
		
		
        <tr>
          <td width="25%" height="30" align="center" bgcolor="#E8E8E8">展会</td>
          <td width="25%" align="center" bgcolor="#FFFFFF"><a href="news/expo.php" style="text-decoration:underline;">查看</a></td>
		  
          <td width="25%" align="center" bgcolor="#FFFFFF"></td>
		  <td align="center" bgcolor="#FFFFFF"><?php
		  $rs=@mysql_query("select count(id) from news where type_id=22 and n_sh='0'");
		   $num=@mysql_result($rs,0);
		  ?>( <a href="news/expo_new.php" style="text-decoration:underline; color:#FF0000;"><?=$num?></a> )</td>
		  <?php mysql_free_result($rs);?>
        </tr>
        <tr>
          <td width="25%" height="30" align="center" bgcolor="#E8E8E8">招标</td>
          <td width="25%" align="center" bgcolor="#FFFFFF"><a href="news/zhaobiao.php" style="text-decoration:underline;">查看</a></td>
		  
          <td width="25%" align="center" bgcolor="#FFFFFF"></td>
		  <td align="center" bgcolor="#FFFFFF"><?php
		  $rs=@mysql_query("select count(id) from news where type_id=1 and n_sh='0'");
		   $num=@mysql_result($rs,0);
		  ?>( <a href="news/zb_new.php" style="text-decoration:underline; color:#FF0000;"><?=$num?></a> )</td>
		  <?php mysql_free_result($rs);?>
        </tr>		
		
        <tr>
          <td width="25%" height="30" align="center" bgcolor="#E8E8E8">招聘岗位</td>
          <td width="25%" align="center" bgcolor="#FFFFFF"><a href="job/index_2.php" style="text-decoration:underline;">查看</a></td>
		  
          <td width="25%" align="center" bgcolor="#FFFFFF">
		  <?php
		  $rs=@mysql_query("select count(id) from job_post where job_sh='0' and job_cl='1'");
		   $num=@mysql_result($rs,0);
		  ?>( <a href="job/index_3.php" style="text-decoration:underline;"><?=$num?></a> )</td>
		  <?php mysql_free_result($rs);?>
          <td align="center" bgcolor="#FFFFFF">
		  <?php
		  $rs=@mysql_query("select count(id) from job_post where job_cl='0'");
		   $num=@mysql_result($rs,0);
		  ?>( <a href="job/index.php" style="text-decoration:underline;"><?=$num?></a> )</td>
		  <?php mysql_free_result($rs);?>
        </tr>
        <tr>
          <td width="25%" height="30" align="center" bgcolor="#E8E8E8">人才管理</td>
          <td width="25%" align="center" bgcolor="#FFFFFF"><a href="job/hr_2.php" style="text-decoration:underline;">查看</a></td>
		  
          <td width="25%" align="center" bgcolor="#FFFFFF">&nbsp;</td>
          <td align="center" bgcolor="#FFFFFF">
		  <?php
		   $rs=@mysql_query("select count(id) from job_per where p_step='0'");
		   $num=@mysql_result($rs,0);
		  ?>( <a href="job/hr.php" style="text-decoration:underline;"><?=$num?></a> )</td>
		  <?php mysql_free_result($rs);?>
        </tr>
        <tr>
          <td width="25%" height="30" align="center" bgcolor="#E8E8E8">最新采购订单</td>
          <td width="25%" align="center" bgcolor="#FFFFFF"><a href="caigou/index_2.php" style="text-decoration:underline;">查看</a></td>
		  <td width="25%" align="center" bgcolor="#FFFFFF">&nbsp;</td>
		  <td align="center" bgcolor="#FFFFFF"><?php 
		  $rs=@mysql_query("SELECT count(id) FROM caigou  where c_cl=0");
		  $num=@mysql_result($rs,0);
		  mysql_free_result($rs);
		  ?>( <a href="caigou/index.php" style="text-decoration:underline;"><?=$num?></a> )</td>
          </tr>
        <tr>
          <td height="30" align="center" bgcolor="#E8E8E8">询价邮件</td>
          <td align="center" bgcolor="#FFFFFF"><?php 
		  $rs=@mysql_query("SELECT count(id) FROM m_message");
		  $num=@mysql_result($rs,0);
		  mysql_free_result($rs);
		  ?>( <a href="mailbox/index.php" style="text-decoration:underline;"><?=$num?></a> )</td>
          <td align="center" bgcolor="#FFFFFF">最新代理加盟留言</td>
          <td align="center" bgcolor="#FFFFFF"><?php 
		  $rs=@mysql_query("SELECT count(id) FROM m_message where m_type=4 and is_jm=0");
		  $num=@mysql_result($rs,0);
		  mysql_free_result($rs);
		  ?>( <a href="mailbox/index_2.php" style="text-decoration:underline;"><?=$num?></a> )</td>
        </tr>
      </table></td>
    </tr>
  </table>

</center>
</BODY>
</HTML>
